package com.iwhalecloud.dict;

import com.iwhalecloud.dict.service.BenefitEvaluation;

import java.math.BigInteger;


public class Test {
    public static void main(String[] args) {
        BenefitEvaluation be= new BenefitEvaluation();
        // 测试EXCEL导入，取数据入数据库
        String oppId="2022101216093741030";
        String filePath="F:\\project\\idea2018.3\\springbootdemo\\target\\classes\\OPP2022101216093741030.xlsx";
        int operType=1;
        //be.operDataFromExcel2DB(oppId,filePath,operType);



        // 测试前端导入数据，后端处理后导入数据库
        // 2022041215140958829
        // 2022101216093741030
        String oppId2="2022101216093741030";

        BigInteger b = new BigInteger(oppId2);

        long opp3 =b.longValue();


        be.operDataFromDb2Excel(opp3,1,202210);

        //PostgreSqlDao dao = new PostgreSqlDao();
        //int out=dao.callProcedure("proc_gen_benefit_eval_result",oppId,operType);

        //System.out.println(out);


    }
}
